跳到主要内容

NumFormat

Standard numeric format.

Type​

Enumeration

Values​

  • "General"
  • "0"
  • "0.00"
  • "#,##0"
  • "#,##0.00"
  • "0%"
  • "0.00%"
  • "0.00E+00"
  • "# ?/?"
  • "# ??/??"
  • "m/d/yyyy"
  • "d-mmm-yy"
  • "d-mmm"
  • "mmm-yy"
  • "h:mm AM/PM"
  • "h:mm:ss AM/PM"
  • "h:mm"
  • "h:mm:ss"
  • "m/d/yyyy h:mm"
  • "#,##0_);(#,##0)"
  • "#,##0_);Red"
  • "#,##0.00_);(#,##0.00)"
  • "#,##0.00_);Red"
  • "mm:ss"
  • "[h]:mm:ss"
  • "mm:ss.0"
  • "##0.0E+0"
  • "@"

Example​

This example shows how to specify that the range contents will be rotated upward.

worksheet.GetRange("A1").SetOrientation("xlUpward");